Data Base Administrator


 
 
Concept Explanation
 

Database Administrator

A Database Administrator (DBA) is an individual or person responsible for controlling, maintaining, coordinating, and operating a database management system. Managing, securing, and taking care of the database systems is a prime responsibility. They are responsible and in charge of authorizing access to the database, coordinating, capacity, planning, installation, and monitoring uses, and acquiring and gathering software and hardware resources as and when needed. Their role also varies from configuration, database design, migration, security, troubleshooting, backup, and data recovery. Database administration is a major and key function in any firm or organization that is relying on one or more databases. They are overall commanders of the Database system.

Various responsibilities of Database Administrator (DBA) :

  • Responsible for designing overall database schema (tables & fields).
  • To select and install database software and hardware.
  • .... (More Text Available, Login?)
    Sample Questions
    (More Questions for each concept available in Login)
    Question : 1

    Which of the following is/are not a responsibility of DBA?

    (i) Responsible for designing overall database schema (tables & fields).

    (ii) To select and install database software and hardware.

    (iii) Responsible for deciding on access methods and data storage.

    Right Option : D
    View Explanation
    Explanation
    Question : 2

    DBA is Responsible for designing overall______________

    Right Option : C
    View Explanation
    Explanation
    Question : 3

    The various programming and soft skills are required to become a DBA. Which of the following statement(s) is/are correct?

    (i) Good communication skills

    (ii) Excellent knowledge of databases architecture and design and RDBMS.

    (iii) Knowledge of Structured Query Language (SQL).

    Right Option : D
    View Explanation
    Explanation
     
     
     


    Students / Parents Reviews [20]